Parallel Period
The Parallel Period functions return a member from a previous period in the same level as the given member. For instance, if a Parallel Quarter calculation is selected, and the given date is Q2 2010, then Q2 2009 is returned.
Parallel Period functions return:
- A parameter, which is used to inject a date into the query at runtime.
- Custom lists, which return a list of dates when added to the query (the parallel period).
Note: the Parallel Period functions are supported by user hierarchies in MS OLAP, Tabular, and BW data models only.
Examples